/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50505
 Source Host           : localhost
 Source Database       : AuthDB

 Target Server Version : 50505
 File Encoding         : utf-8

 Date: 02/28/2017 16:00:30 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `au_rule`
-- ----------------------------
DROP TABLE IF EXISTS `au_rule`;
CREATE TABLE `au_rule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(30) NOT NULL COMMENT '用户可以访问的地址',
  `users_id` int(11) NOT NULL COMMENT '用户编号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `au_rule`
-- ----------------------------
BEGIN;
INSERT INTO `au_rule` VALUES ('1', 'admin/index/addUser', '1'), ('2', 'admin/index/deleteUser', '1');
COMMIT;

-- ----------------------------
--  Table structure for `au_users`
-- ----------------------------
DROP TABLE IF EXISTS `au_users`;
CREATE TABLE `au_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loginname` varchar(20) NOT NULL,
  `password` varchar(64) NOT NULL,
  `statues` int(11) NOT NULL DEFAULT '1' COMMENT '用户状态1-正常 2-禁用',
  `isdelete` int(11) NOT NULL DEFAULT '0' COMMENT '软删除 1 -已删除 0 正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `au_users`
-- ----------------------------
BEGIN;
INSERT INTO `au_users` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '1', '0'), ('2', 'guan', 'e10adc3949ba59abbe56e057f20f883e', '1', '0'), ('3', 'li', 'e10adc3949ba59abbe56e057f20f883e', '1', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
